Loan Profiling Report

Dataset info

Number of variables	75
Number of observations	877986
Missing cells	0 (0.0%)
Duplicate rows	0 (0.0%)
Total size in memory	502.4 MiB
Average record size in memory	600.0 B

Variables types

Numeric	47
Categorical	13
Boolean	3
Date	0
URL	0
Text (Unique)	0
Rejected	12
Unsupported	0

Warnings

`acc_now_delinq` has 873344 (99.5%) zeros	Zeros
`acc_open_past_24mths` has 36913 (4.2%) zeros	Zeros
`annual_inc` is highly skewed (γ1 = 481.5767234)	Skewed
`chargeoff_within_12_mths` has 870928 (99.2%) zeros	Zeros
`collection_recovery_fee` has 833279 (94.9%) zeros	Zeros
`collections_12_mths_ex_med` has 860256 (98.0%) zeros	Zeros
`delinq_2yrs` has 699379 (79.7%) zeros	Zeros
`delinq_amnt` is highly skewed (γ1 = 86.71946315)	Skewed
`delinq_amnt` has 873983 (99.5%) zeros	Zeros
`earliest_cr_line` has a high cardinality: 709 distinct values	Warning
`fico_range_low` is highly correlated with `fico_range_high` (ρ = 0.9999999033)	Rejected
`funded_amnt_inv` is highly correlated with `funded_amnt` (ρ = 0.9999934741)	Rejected
`installment` is highly correlated with `funded_amnt_inv` (ρ = 0.9482554488)	Rejected
`last_fico_range_low` has 11866 (1.4%) zeros	Zeros
`loan_amnt` is highly correlated with `installment` (ρ = 0.9483703021)	Rejected
`mo_sin_rcnt_rev_tl_op` has 13591 (1.5%) zeros	Zeros
`mo_sin_rcnt_tl` has 14028 (1.6%) zeros	Zeros
`mort_acc` has 370578 (42.2%) zeros	Zeros
`num_accts_ever_120_pd` has 666796 (75.9%) zeros	Zeros
`num_actv_bc_tl` has 20219 (2.3%) zeros	Zeros
`num_bc_sats` has 9947 (1.1%) zeros	Zeros
`num_il_tl` has 24904 (2.8%) zeros	Zeros
`num_rev_tl_bal_gt_0` is highly correlated with `num_actv_rev_tl` (ρ = 0.9784947354)	Rejected
`num_tl_30dpd` has 874894 (99.6%) zeros	Zeros
`num_tl_90g_dpd_24m` has 828135 (94.3%) zeros	Zeros
`num_tl_op_past_12m` has 163858 (18.7%) zeros	Zeros
`open_acc` is highly correlated with `num_sats` (ρ = 0.9988132903)	Rejected
`out_prncp` has 345363 (39.3%) zeros	Zeros
`out_prncp_inv` is highly correlated with `out_prncp` (ρ = 0.9999980186)	Rejected
`policy_code` has constant value "1"	Rejected
`pub_rec` has 718878 (81.9%) zeros	Zeros
`pub_rec_bankruptcies` has 764266 (87.0%) zeros	Zeros
`recoveries` is highly correlated with `collection_recovery_fee` (ρ = 0.9864791705)	Rejected
`tax_liens` is highly skewed (γ1 = 23.34781072)	Skewed
`tax_liens` has 843069 (96.0%) zeros	Zeros
`tot_coll_amt` is highly skewed (γ1 = 151.083683)	Skewed
`tot_coll_amt` has 729825 (83.1%) zeros	Zeros
`tot_hi_cred_lim` is highly correlated with `tot_cur_bal` (ρ = 0.972754613)	Rejected
`total_bc_limit` has 10424 (1.2%) zeros	Zeros
`total_il_high_credit_limit` has 94263 (10.7%) zeros	Zeros
`total_pymnt_inv` is highly correlated with `total_pymnt` (ρ = 0.9999946425)	Rejected
`total_rec_late_fee` is highly skewed (γ1 = 20.29350981)	Skewed
`total_rec_late_fee` has 844499 (96.2%) zeros	Zeros
`total_rec_prncp` is highly correlated with `total_pymnt_inv` (ρ = 0.9665829516)	Rejected

acc_now_delinq
Numeric

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.005606011941
Minimum	0
Maximum	7
Zeros (%)	99.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	7
Range	7
Interquartile range	0

Descriptive statistics

Standard deviation	0.079666892
Coef of variation	14.21097437
Kurtosis	396.9390178
Mean	0.005606011941
MAD	0.01115274479
Skewness	16.71443451
Sum	4922
Variance	0.00634681368
Memory size	6.7 MiB

Histogram with fixed size bins (bins=7)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 7. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	873344	99.5%
1	4401	0.5%
2	213	< 0.1%
3	22	< 0.1%
4	4	< 0.1%
7	1	< 0.1%
6	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	873344	99.5%
1	4401	0.5%
2	213	< 0.1%
3	22	< 0.1%
4	4	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
7	1	< 0.1%
6	1	< 0.1%
4	4	< 0.1%
3	22	< 0.1%
2	213	< 0.1%

acc_open_past_24mths
Numeric

Distinct count	52
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.659733754
Minimum	0
Maximum	61
Zeros (%)	4.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
Median	4
Q3	6
95-th percentile	11
Maximum	61
Range	61
Interquartile range	4

Descriptive statistics

Standard deviation	3.262668052
Coef of variation	0.7001833633
Kurtosis	4.763240446
Mean	4.659733754
MAD	2.483325368
Skewness	1.451089178
Sum	4091181
Variance	10.64500282
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 29.5 33.5 37.5 47. 61. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
3	129315	14.7%
4	120911	13.8%
2	117647	13.4%
5	102741	11.7%
1	84938	9.7%
6	80886	9.2%
7	61014	6.9%
8	44203	5.0%
0	36913	4.2%
9	31224	3.6%
Other values (42)	68194	7.8%

Minimum 5 values

Value	Count	Frequency (%)
0	36913	4.2%
1	84938	9.7%
2	117647	13.4%
3	129315	14.7%
4	120911	13.8%

Maximum 5 values

Value	Count	Frequency (%)
61	1	< 0.1%
56	1	< 0.1%
55	1	< 0.1%
54	2	< 0.1%
49	2	< 0.1%

addr_state
Categorical

Distinct count	50
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

CA	117739
TX	74295
NY	72705
Other values (47)	613247

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CA	117739	13.4%
TX	74295	8.5%
NY	72705	8.3%
FL	63663	7.3%
IL	36022	4.1%
NJ	32066	3.7%
PA	29547	3.4%
OH	29463	3.4%
GA	28712	3.3%
NC	24375	2.8%
Other values (40)	369399	42.1%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

annual_inc
Numeric

Distinct count	46617
Unique (%)	5.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	79805.0889
Minimum	0
Maximum	110000000
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	28000
Q1	47500
Median	66000
Q3	95000
95-th percentile	166000
Maximum	110000000
Range	110000000
Interquartile range	47500

Descriptive statistics

Standard deviation	154922.5767
Coef of variation	1.941261878
Kurtosis	316133.8167
Mean	79805.0889
MAD	35726.73393
Skewness	481.5767234
Sum	7.006775078e+10
Variance	2.400100478e+10
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 1.8000000e-01 1.5000000e+00 1.0750000e+02 8.7500000e+02 ... 1.4940000e+06 1.5040000e+06 5.6108570e+06 1.0286136e+07 1.1000000e+08], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
60000	33974	3.9%
50000	29252	3.3%
65000	25228	2.9%
70000	24271	2.8%
80000	23598	2.7%
75000	23037	2.6%
40000	22726	2.6%
45000	20494	2.3%
55000	19739	2.2%
100000	18679	2.1%
Other values (46607)	636988	72.6%

Minimum 5 values

Value	Count	Frequency (%)
0	550	0.1%
0.36	1	< 0.1%
1	21	< 0.1%
2	1	< 0.1%
6	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
110000000	1	< 0.1%
61000000	1	< 0.1%
10999200	1	< 0.1%
9573072	1	< 0.1%
9550000	1	< 0.1%

application_type
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Individual	826772
Joint App	51214

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Individual	826772	94.2%
Joint App	51214	5.8%

Max length	10
Mean length	9.941668774
Min length	9
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

chargeoff_within_12_mths
Numeric

Distinct count	10
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.008942056024
Minimum	0
Maximum	9
Zeros (%)	99.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	9
Range	9
Interquartile range	0

Descriptive statistics

Standard deviation	0.1082632187
Coef of variation	12.1071953
Kurtosis	617.3394845
Mean	0.008942056024
MAD	0.01774034431
Skewness	18.28569017
Sum	7851
Variance	0.01172092452
Memory size	6.7 MiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 9. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	870928	99.2%
1	6513	0.7%
2	405	< 0.1%
3	83	< 0.1%
4	34	< 0.1%
5	11	< 0.1%
6	4	< 0.1%
9	3	< 0.1%
7	3	< 0.1%
8	2	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	870928	99.2%
1	6513	0.7%
2	405	< 0.1%
3	83	< 0.1%
4	34	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
9	3	< 0.1%
8	2	< 0.1%
7	3	< 0.1%
6	4	< 0.1%
5	11	< 0.1%

collection_recovery_fee
Numeric

Distinct count	38735
Unique (%)	4.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	16.44041308
Minimum	0
Maximum	7174.719
Zeros (%)	94.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	11.6352
Maximum	7174.719
Range	7174.719
Interquartile range	0

Descriptive statistics

Standard deviation	101.8510925
Coef of variation	6.195166267
Kurtosis	315.9564187
Mean	16.44041308
MAD	31.22513432
Skewness	12.73134475
Sum	14434452.52
Variance	10373.64505
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 1.54100000e-01 8.99999994e-01 8.99999997e-01 3.59999999e+00 ... 1.45857870e+03 2.08460520e+03 2.84027850e+03 4.25406780e+03 7.17471900e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	833279	94.9%
9	305	< 0.1%
18	300	< 0.1%
27	178	< 0.1%
36	166	< 0.1%
4.5	159	< 0.1%
13.5	118	< 0.1%
54	114	< 0.1%
45	92	< 0.1%
72	78	< 0.1%
Other values (38725)	43197	4.9%

Minimum 5 values

Value	Count	Frequency (%)
0	833279	94.9%
0.3082	1	< 0.1%
0.378	1	< 0.1%
0.809999997	1	< 0.1%
0.8514	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
7174.719	1	< 0.1%
6687.6228	1	< 0.1%
6584.1372	1	< 0.1%
5510.133	1	< 0.1%
5381.1288	1	< 0.1%

collections_12_mths_ex_med
Numeric

Distinct count	14
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.02221561619
Minimum	0
Maximum	20
Zeros (%)	98.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	20
Range	20
Interquartile range	0

Descriptive statistics

Standard deviation	0.1679709665
Coef of variation	7.560941142
Kurtosis	488.6881999
Mean	0.02221561619
MAD	0.04353399058
Skewness	12.92177996
Sum	19505
Variance	0.02821424558
Memory size	6.7 MiB

Histogram with fixed size bins (bins=14)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 5.5 7.5 20. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	860256	98.0%
1	16410	1.9%
2	1086	0.1%
3	136	< 0.1%
4	52	< 0.1%
5	21	< 0.1%
6	10	< 0.1%
7	6	< 0.1%
9	3	< 0.1%
12	2	< 0.1%
Other values (4)	4	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	860256	98.0%
1	16410	1.9%
2	1086	0.1%
3	136	< 0.1%
4	52	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
20	1	< 0.1%
12	2	< 0.1%
11	1	< 0.1%
10	1	< 0.1%
9	3	< 0.1%

debt_settlement_flag
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	867536
Y	10450

Toggle details

Value	Count	Frequency (%)
N	867536	98.8%
Y	10450	1.2%

delinq_2yrs
Numeric

Distinct count	32
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.3430248318
Minimum	0
Maximum	42
Zeros (%)	79.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	2
Maximum	42
Range	42
Interquartile range	0

Descriptive statistics

Standard deviation	0.9318478553
Coef of variation	2.716560927
Kurtosis	61.73846831
Mean	0.3430248318
MAD	0.5464879027
Skewness	5.672934529
Sum	301171
Variance	0.8683404254
Memory size	6.7 MiB

Histogram with fixed size bins (bins=32)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 12.5 14.5 16.5 21.5 42. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	699379	79.7%
1	117081	13.3%
2	34949	4.0%
3	13136	1.5%
4	5875	0.7%
5	2981	0.3%
6	1728	0.2%
7	1005	0.1%
8	593	0.1%
9	399	< 0.1%
Other values (22)	860	0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	699379	79.7%
1	117081	13.3%
2	34949	4.0%
3	13136	1.5%
4	5875	0.7%

Maximum 5 values

Value	Count	Frequency (%)
42	1	< 0.1%
36	1	< 0.1%
32	1	< 0.1%
30	1	< 0.1%
29	1	< 0.1%

delinq_amnt
Numeric

Distinct count	1817
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	19.69888244
Minimum	0
Maximum	249925
Zeros (%)	99.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	249925
Range	249925
Interquartile range	0

Descriptive statistics

Standard deviation	942.7004631
Coef of variation	47.85553017
Kurtosis	11740.37531
Mean	19.69888244
MAD	39.2215967
Skewness	86.71946315
Sum	17295343
Variance	888684.1631
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000e+00 5.00000e-01 2.45000e+01 2.55000e+01 2.65000e+01 ... 3.07525e+04 4.79340e+04 6.44565e+04 6.53090e+04 2.49925e+05], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	873983	99.5%
25	88	< 0.1%
65000	75	< 0.1%
57	37	< 0.1%
30	36	< 0.1%
54	34	< 0.1%
53	34	< 0.1%
50	33	< 0.1%
56	31	< 0.1%
35	28	< 0.1%
Other values (1807)	3607	0.4%

Minimum 5 values

Value	Count	Frequency (%)
0	873983	99.5%
1	7	< 0.1%
2	9	< 0.1%
3	8	< 0.1%
4	11	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
249925	1	< 0.1%
185408	1	< 0.1%
138474	1	< 0.1%
130778	1	< 0.1%
112524	1	< 0.1%

df_index
Numeric

Distinct count	133887
Unique (%)	15.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	55619.21042
Minimum	0
Maximum	133886
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	5487
Q1	27437
Median	54874
Q3	82311
95-th percentile	110445
Maximum	133886
Range	133886
Interquartile range	54874

Descriptive statistics

Standard deviation	33005.8217
Coef of variation	0.5934248518
Kurtosis	-0.9813619468
Mean	55619.21042
MAD	28187.71313
Skewness	0.1430938585
Sum	4.883288808e+10
Variance	1089384266
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 96778.5 97853.5 99119.5 103545.5 105450.5 118647.5 122700.5 133886. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2047	8	< 0.1%
67301	8	< 0.1%
65242	8	< 0.1%
63195	8	< 0.1%
52956	8	< 0.1%
50909	8	< 0.1%
57054	8	< 0.1%
55007	8	< 0.1%
77536	8	< 0.1%
75489	8	< 0.1%
Other values (133877)	877906	> 99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	8	< 0.1%
1	8	< 0.1%
2	8	< 0.1%
3	8	< 0.1%
4	8	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
133886	1	< 0.1%
133885	1	< 0.1%
133884	1	< 0.1%
133883	1	< 0.1%
133882	1	< 0.1%

disbursement_method
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Cash	871222
DirectPay	6764

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Cash	871222	99.2%
DirectPay	6764	0.8%

Max length	9
Mean length	4.038519976
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

earliest_cr_line
Categorical

Distinct count	709
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

Sep-05	6687
Sep-04	6650
Aug-04	6412
Other values (706)	858237

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Sep-05	6687	0.8%
Sep-04	6650	0.8%
Aug-04	6412	0.7%
Sep-03	6372	0.7%
Aug-05	6356	0.7%
Aug-03	6303	0.7%
Aug-06	6091	0.7%
Oct-03	5965	0.7%
Oct-04	5911	0.7%
Aug-02	5717	0.7%
Other values (699)	815522	92.9%

Max length	6
Mean length	6
Min length	6
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

fico_range_high
Numeric

Distinct count	38
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	701.8635081
Minimum	664
Maximum	850
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	664
5-th percentile	664
Q1	674
Median	694
Q3	719
95-th percentile	769
Maximum	850
Range	186
Interquartile range	45

Descriptive statistics

Standard deviation	32.93544331
Coef of variation	0.04692570982
Kurtosis	1.438569926
Mean	701.8635081
MAD	25.74123018
Skewness	1.226548943
Sum	616226334
Variance	1084.743426
Memory size	6.7 MiB

Histogram with fixed size bins (bins=38)

Histogram with variable size bins (bins=[664. 666.5 676.5 686.5 691.5 ... 826.5 831.5 836.5 841.5 850. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
664	77523	8.8%
669	73290	8.3%
674	72175	8.2%
684	65119	7.4%
679	64462	7.3%
689	56694	6.5%
694	55524	6.3%
699	49706	5.7%
704	47826	5.4%
709	43060	4.9%
Other values (28)	272607	31.0%

Minimum 5 values

Value	Count	Frequency (%)
664	77523	8.8%
669	73290	8.3%
674	72175	8.2%
679	64462	7.3%
684	65119	7.4%

Maximum 5 values

Value	Count	Frequency (%)
850	185	< 0.1%
844	256	< 0.1%
839	347	< 0.1%
834	587	0.1%
829	862	0.1%

fico_range_low
Highly correlated

This variable is highly correlated with fico_range_high and should be ignored for analysis

Correlation	0.9999999033

funded_amnt
Numeric

Distinct count	1560
Unique (%)	0.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	14790.09776
Minimum	1000
Maximum	40000
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1000
5-th percentile	3000
Q1	7500
Median	12000
Q3	20000
95-th percentile	35000
Maximum	40000
Range	39000
Interquartile range	12500

Descriptive statistics

Standard deviation	9321.148083
Coef of variation	0.6302289702
Kurtosis	-0.1175966129
Mean	14790.09776
MAD	7563.617806
Skewness	0.8038443875
Sum	1.298549878e+10
Variance	86883801.58
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1000. 1012.5 1087.5 1112.5 1187.5 ... 39212.5 39587.5 39612.5 39987.5 40000. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
10000	69756	7.9%
20000	48229	5.5%
12000	47703	5.4%
15000	45620	5.2%
5000	36217	4.1%
35000	32655	3.7%
8000	31928	3.6%
6000	30539	3.5%
16000	27569	3.1%
30000	24035	2.7%
Other values (1550)	483735	55.1%

Minimum 5 values

Value	Count	Frequency (%)
1000	4495	0.5%
1025	16	< 0.1%
1050	24	< 0.1%
1075	9	< 0.1%
1100	108	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
40000	13052	1.5%
39975	7	< 0.1%
39950	3	< 0.1%
39925	5	< 0.1%
39900	8	< 0.1%

funded_amnt_inv
Highly correlated

This variable is highly correlated with funded_amnt and should be ignored for analysis

Correlation	0.9999934741

grade
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

C	277322
B	267639
A	149643
Other values (4)	183382

Toggle details

Common values
Composition

Value	Count	Frequency (%)
C	277322	31.6%
B	267639	30.5%
A	149643	17.0%
D	115824	13.2%
E	45974	5.2%
F	15576	1.8%
G	6008	0.7%

Max length	1
Mean length	1
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

hardship_flag
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

N	877038
Y	948

Toggle details

Value	Count	Frequency (%)
N	877038	99.9%
Y	948	0.1%

home_ownership
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

MORTGAGE	428639
RENT	343387
OWN	105451
Other values (2)	509

Toggle details

Common values
Composition

Value	Count	Frequency (%)
MORTGAGE	428639	48.8%
RENT	343387	39.1%
OWN	105451	12.0%
ANY	505	0.1%
NONE	4	< 0.1%

Max length	8
Mean length	5.832147665
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

initial_list_status
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

w	677742
f	200244

Toggle details

Common values
Composition

Value	Count	Frequency (%)
w	677742	77.2%
f	200244	22.8%

Max length	1
Mean length	1
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

installment
Highly correlated

This variable is highly correlated with funded_amnt_inv and should be ignored for analysis

Correlation	0.9482554488

int_rate
Numeric

Distinct count	170
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.14438129
Minimum	5.32
Maximum	30.99
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	5.32
5-th percentile	6.49
Q1	9.49
Median	12.62
Q3	15.59
95-th percentile	23.88
Maximum	30.99
Range	25.67
Interquartile range	6.1

Descriptive statistics

Standard deviation	5.06407089
Coef of variation	0.3852650634
Kurtosis	1.059300223
Mean	13.14438129
MAD	3.886553356
Skewness	0.973944813
Sum	11540582.75
Variance	25.64481398
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 5.32 5.66 6.04 6.16 6.365 ... 30.745 30.77 30.815 30.965 30.99 ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5.32	34988	4.0%
11.99	34292	3.9%
11.49	28896	3.3%
13.99	23957	2.7%
13.49	23235	2.6%
16.02	20509	2.3%
12.74	19990	2.3%
12.62	19663	2.2%
10.42	19235	2.2%
9.44	18919	2.2%
Other values (160)	634302	72.2%

Minimum 5 values

Value	Count	Frequency (%)
5.32	34988	4.0%
6	274	< 0.1%
6.08	2670	0.3%
6.24	9	< 0.1%
6.49	6416	0.7%

Maximum 5 values

Value	Count	Frequency (%)
30.99	792	0.1%
30.94	708	0.1%
30.89	655	0.1%
30.84	667	0.1%
30.79	1085	0.1%

issue_d
Categorical

Distinct count	24
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Mar-16	61992
Aug-17	43573
Nov-17	42343
Other values (21)	730078

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Mar-16	61992	7.1%
Aug-17	43573	5.0%
Nov-17	42343	4.8%
Sep-17	39713	4.5%
Feb-16	39529	4.5%
Jul-17	39415	4.5%
Dec-17	38154	4.3%
Oct-17	38151	4.3%
Jun-17	38087	4.3%
May-17	37681	4.3%
Other values (14)	459348	52.3%

Max length	6
Mean length	6
Min length	6
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

last_fico_range_high
Numeric

Distinct count	72
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	688.4523364
Minimum	0
Maximum	850
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	544
Q1	659
Median	699
Q3	729
95-th percentile	789
Maximum	850
Range	850
Interquartile range	70

Descriptive statistics

Standard deviation	68.32214293
Coef of variation	0.09924019329
Kurtosis	0.7346573402
Mean	688.4523364
MAD	51.36481061
Skewness	-0.7675556368
Sum	604451513
Variance	4667.915215
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 249.5 501.5 506.5 511.5 ... 831.5 836.5 841.5 847. 850. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
694	35363	4.0%
699	34749	4.0%
704	34453	3.9%
709	34035	3.9%
684	33883	3.9%
714	33108	3.8%
689	33065	3.8%
719	31941	3.6%
724	30783	3.5%
679	29984	3.4%
Other values (62)	546622	62.3%

Minimum 5 values

Value	Count	Frequency (%)
0	22	< 0.1%
499	11844	1.3%
504	2518	0.3%
509	2859	0.3%
514	3276	0.4%

Maximum 5 values

Value	Count	Frequency (%)
850	102	< 0.1%
844	275	< 0.1%
839	461	0.1%
834	1014	0.1%
829	1738	0.2%

last_fico_range_low
Numeric

Distinct count	71
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	677.774788
Minimum	0
Maximum	845
Zeros (%)	1.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	540
Q1	655
Median	695
Q3	725
95-th percentile	785
Maximum	845
Range	845
Interquartile range	70

Descriptive statistics

Standard deviation	102.2677072
Coef of variation	0.1508874467
Kurtosis	23.58245973
Mean	677.774788
MAD	59.34179145
Skewness	-3.990956813
Sum	595076775
Variance	10458.68394
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 250. 502.5 507.5 512.5 ... 822.5 827.5 832.5 837.5 845. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
690	35363	4.0%
695	34749	4.0%
700	34453	3.9%
705	34035	3.9%
680	33883	3.9%
710	33108	3.8%
685	33065	3.8%
715	31941	3.6%
720	30783	3.5%
675	29984	3.4%
Other values (61)	546622	62.3%

Minimum 5 values

Value	Count	Frequency (%)
0	11866	1.4%
500	2518	0.3%
505	2859	0.3%
510	3276	0.4%
515	3536	0.4%

Maximum 5 values

Value	Count	Frequency (%)
845	102	< 0.1%
840	275	< 0.1%
835	461	0.1%
830	1014	0.1%
825	1738	0.2%

last_pymnt_amnt
Numeric

Distinct count	291190
Unique (%)	33.2%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3223.427883
Minimum	0
Maximum	42192.05
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	106.95
Q1	288.5
Median	526.63
Q3	2412.48
95-th percentile	17267.5325
Maximum	42192.05
Range	42192.05
Interquartile range	2123.98

Descriptive statistics

Standard deviation	6144.658282
Coef of variation	1.906249652
Kurtosis	7.925814539
Mean	3223.427883
MAD	4121.576768
Skewness	2.7438481
Sum	2830124554
Variance	37756825.4
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-03 1.5000000e-02 1.0500000e-01 9.9500000e-01 ... 4.0022725e+04 4.0103170e+04 4.0759730e+04 4.1443535e+04 4.2192050e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
301.15	2046	0.2%
332.1	1791	0.2%
329.72	1518	0.2%
361.38	1419	0.2%
602.3	1394	0.2%
451.73	1377	0.2%
324.65	1322	0.2%
320.05	1265	0.1%
326.97	1259	0.1%
335.12	1200	0.1%
Other values (291180)	863395	98.3%

Minimum 5 values

Value	Count	Frequency (%)
0	1182	0.1%
0.01	68	< 0.1%
0.02	12	< 0.1%
0.03	6	< 0.1%
0.04	8	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
42192.05	1	< 0.1%
42148.53	1	< 0.1%
42005.2	1	< 0.1%
41453.07	1	< 0.1%
41434	1	< 0.1%

loan_amnt
Highly correlated

This variable is highly correlated with installment and should be ignored for analysis

Correlation	0.9483703021

loan_status
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Current	503359
Fully Paid	264241
Charged Off	80804
Other values (4)	29582

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Current	503359	57.3%
Fully Paid	264241	30.1%
Charged Off	80804	9.2%
Late (31-120 days)	16259	1.9%
In Grace Period	8052	0.9%
Late (16-30 days)	4505	0.5%
Default	766	0.1%

Max length	18
Mean length	8.599403635
Min length	7
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

mo_sin_old_rev_tl_op
Numeric

Distinct count	744
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	182.3199618
Minimum	1
Maximum	999
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	47
Q1	117
Median	164
Q3	234
95-th percentile	372
Maximum	999
Range	998
Interquartile range	117

Descriptive statistics

Standard deviation	98.46138068
Coef of variation	0.5400471769
Kurtosis	1.282080379
Mean	182.3199618
MAD	76.15936788
Skewness	0.9804793666
Sum	160074374
Variance	9694.643484
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 1. 4.5 7.5 11.5 12.5 ... 649.5 694.5 733. 819. 999. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
132	5265	0.6%
125	5226	0.6%
130	5211	0.6%
129	5179	0.6%
136	5171	0.6%
133	5128	0.6%
126	5120	0.6%
135	5109	0.6%
127	5101	0.6%
124	5096	0.6%
Other values (734)	826380	94.1%

Minimum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	< 0.1%
3	3	< 0.1%
4	5	< 0.1%
5	14	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
999	1	< 0.1%
901	1	< 0.1%
852	1	< 0.1%
836	1	< 0.1%
821	1	< 0.1%

mo_sin_rcnt_rev_tl_op
Numeric

Distinct count	292
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.91459773
Minimum	0
Maximum	547
Zeros (%)	1.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	4
Median	8
Q3	17
95-th percentile	45
Maximum	547
Range	547
Interquartile range	13

Descriptive statistics

Standard deviation	17.57807197
Coef of variation	1.263282799
Kurtosis	23.2576125
Mean	13.91459773
MAD	11.05273815
Skewness	3.709751662
Sum	12216822
Variance	308.9886141
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 3.500e+00 ... 2.165e+02 2.675e+02 2.970e+02 3.945e+02 5.470e+02], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	67436	7.7%
3	65754	7.5%
4	60102	6.8%
1	54709	6.2%
5	53896	6.1%
6	47462	5.4%
7	43812	5.0%
8	39313	4.5%
9	34521	3.9%
10	31111	3.5%
Other values (282)	379870	43.3%

Minimum 5 values

Value	Count	Frequency (%)
0	13591	1.5%
1	54709	6.2%
2	67436	7.7%
3	65754	7.5%
4	60102	6.8%

Maximum 5 values

Value	Count	Frequency (%)
547	1	< 0.1%
438	1	< 0.1%
396	1	< 0.1%
393	1	< 0.1%
373	1	< 0.1%

mo_sin_rcnt_tl
Numeric

Distinct count	202
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	8.159731476
Minimum	0
Maximum	314
Zeros (%)	1.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
Median	6
Q3	10
95-th percentile	23
Maximum	314
Range	314
Interquartile range	7

Descriptive statistics

Standard deviation	8.993482465
Coef of variation	1.102178729
Kurtosis	48.98798084
Mean	8.159731476
MAD	5.623877314
Skewness	4.76692686
Sum	7164130
Variance	80.88272686
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 126.5 136.5 150.5 184.5 314. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
2	95240	10.8%
3	93410	10.6%
4	83093	9.5%
5	71489	8.1%
1	71478	8.1%
6	61160	7.0%
7	54360	6.2%
8	45881	5.2%
9	37987	4.3%
10	32700	3.7%
Other values (192)	231188	26.3%

Minimum 5 values

Value	Count	Frequency (%)
0	14028	1.6%
1	71478	8.1%
2	95240	10.8%
3	93410	10.6%
4	83093	9.5%

Maximum 5 values

Value	Count	Frequency (%)
314	1	< 0.1%
289	1	< 0.1%
283	1	< 0.1%
272	1	< 0.1%
268	1	< 0.1%

mort_acc
Numeric

Distinct count	39
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.484670598
Minimum	0
Maximum	94
Zeros (%)	42.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	1
Q3	2
95-th percentile	5
Maximum	94
Range	94
Interquartile range	2

Descriptive statistics

Standard deviation	1.808425371
Coef of variation	1.218065053
Kurtosis	14.8338169
Mean	1.484670598
MAD	1.433236482
Skewness	1.842605622
Sum	1303520
Variance	3.270402321
Memory size	6.7 MiB

Histogram with fixed size bins (bins=39)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 17.5 19.5 23.5 32. 94. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	370578	42.2%
1	162986	18.6%
2	133820	15.2%
3	92167	10.5%
4	56990	6.5%
5	31032	3.5%
6	15803	1.8%
7	7411	0.8%
8	3544	0.4%
9	1700	0.2%
Other values (29)	1955	0.2%

Minimum 5 values

Value	Count	Frequency (%)
0	370578	42.2%
1	162986	18.6%
2	133820	15.2%
3	92167	10.5%
4	56990	6.5%

Maximum 5 values

Value	Count	Frequency (%)
94	1	< 0.1%
61	1	< 0.1%
51	1	< 0.1%
45	1	< 0.1%
41	1	< 0.1%

num_accts_ever_120_pd
Numeric

Distinct count	42
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.5359128733
Minimum	0
Maximum	51
Zeros (%)	75.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	3
Maximum	51
Range	51
Interquartile range	0

Descriptive statistics

Standard deviation	1.428509243
Coef of variation	2.665562471
Kurtosis	53.77908784
Mean	0.5359128733
MAD	0.8140097001
Skewness	5.512583888
Sum	470524
Variance	2.040638657
Memory size	6.7 MiB

Histogram with fixed size bins (bins=42)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 18.5 23.5 30.5 37. 51. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	666796	75.9%
1	112092	12.8%
2	44275	5.0%
3	20746	2.4%
4	12252	1.4%
5	7182	0.8%
6	4835	0.6%
7	3067	0.3%
8	2043	0.2%
9	1318	0.2%
Other values (32)	3380	0.4%

Minimum 5 values

Value	Count	Frequency (%)
0	666796	75.9%
1	112092	12.8%
2	44275	5.0%
3	20746	2.4%
4	12252	1.4%

Maximum 5 values

Value	Count	Frequency (%)
51	1	< 0.1%
45	1	< 0.1%
42	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%

num_actv_bc_tl
Numeric

Distinct count	39
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.662168873
Minimum	0
Maximum	47
Zeros (%)	2.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
Median	3
Q3	5
95-th percentile	8
Maximum	47
Range	47
Interquartile range	3

Descriptive statistics

Standard deviation	2.361752043
Coef of variation	0.64490528
Kurtosis	5.052618239
Mean	3.662168873
MAD	1.777100994
Skewness	1.548370467
Sum	3215333
Variance	5.57787271
Memory size	6.7 MiB

Histogram with fixed size bins (bins=39)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 21.5 24.5 27.5 34. 47. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
3	182286	20.8%
2	180084	20.5%
4	140458	16.0%
1	107452	12.2%
5	94053	10.7%
6	59411	6.8%
7	36316	4.1%
8	22131	2.5%
0	20219	2.3%
9	13564	1.5%
Other values (29)	22012	2.5%

Minimum 5 values

Value	Count	Frequency (%)
0	20219	2.3%
1	107452	12.2%
2	180084	20.5%
3	182286	20.8%
4	140458	16.0%

Maximum 5 values

Value	Count	Frequency (%)
47	1	< 0.1%
46	1	< 0.1%
37	1	< 0.1%
36	2	< 0.1%
35	1	< 0.1%

num_actv_rev_tl
Numeric

Distinct count	55
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	5.614002957
Minimum	0
Maximum	63
Zeros (%)	0.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
Median	5
Q3	7
95-th percentile	12
Maximum	63
Range	63
Interquartile range	4

Descriptive statistics

Standard deviation	3.455828121
Coef of variation	0.6155729071
Kurtosis	5.583865027
Mean	5.614002957
MAD	2.577306607
Skewness	1.661646067
Sum	4929016
Variance	11.942748
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 32.5 36.5 38.5 47.5 63. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
4	133167	15.2%
3	125512	14.3%
5	119633	13.6%
6	97309	11.1%
2	89816	10.2%
7	74645	8.5%
8	55078	6.3%
9	40200	4.6%
1	35761	4.1%
10	28687	3.3%
Other values (45)	78178	8.9%

Minimum 5 values

Value	Count	Frequency (%)
0	4515	0.5%
1	35761	4.1%
2	89816	10.2%
3	125512	14.3%
4	133167	15.2%

Maximum 5 values

Value	Count	Frequency (%)
63	1	< 0.1%
60	1	< 0.1%
59	1	< 0.1%
57	2	< 0.1%
52	1	< 0.1%

num_bc_sats
Numeric

Distinct count	53
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.779800589
Minimum	0
Maximum	71
Zeros (%)	1.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
Median	4
Q3	6
95-th percentile	11
Maximum	71
Range	71
Interquartile range	3

Descriptive statistics

Standard deviation	3.131138976
Coef of variation	0.6550773233
Kurtosis	7.152841703
Mean	4.779800589
MAD	2.302844194
Skewness	1.825918374
Sum	4196598
Variance	9.804031285
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 31.5 37.5 43.5 49.5 71. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
3	151517	17.3%
4	140413	16.0%
2	124712	14.2%
5	112536	12.8%
6	83385	9.5%
1	62847	7.2%
7	58886	6.7%
8	40786	4.6%
9	27942	3.2%
10	19214	2.2%
Other values (43)	55748	6.3%

Minimum 5 values

Value	Count	Frequency (%)
0	9947	1.1%
1	62847	7.2%
2	124712	14.2%
3	151517	17.3%
4	140413	16.0%

Maximum 5 values

Value	Count	Frequency (%)
71	1	< 0.1%
61	1	< 0.1%
54	2	< 0.1%
50	1	< 0.1%
49	2	< 0.1%

num_bc_tl
Numeric

Distinct count	70
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	7.431093434
Minimum	0
Maximum	79
Zeros (%)	0.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
Median	6
Q3	10
95-th percentile	16
Maximum	79
Range	79
Interquartile range	6

Descriptive statistics

Standard deviation	4.595423158
Coef of variation	0.618404707
Kurtosis	4.458419851
Mean	7.431093434
MAD	3.481089097
Skewness	1.501674051
Sum	6524396
Variance	21.117914
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 39.5 43.5 46.5 58.5 79. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
5	96280	11.0%
4	94939	10.8%
6	90906	10.4%
7	81645	9.3%
3	79440	9.0%
8	70915	8.1%
9	58673	6.7%
2	53503	6.1%
10	48059	5.5%
11	38819	4.4%
Other values (60)	164807	18.8%

Minimum 5 values

Value	Count	Frequency (%)
0	2667	0.3%
1	21873	2.5%
2	53503	6.1%
3	79440	9.0%
4	94939	10.8%

Maximum 5 values

Value	Count	Frequency (%)
79	1	< 0.1%
77	1	< 0.1%
76	1	< 0.1%
70	1	< 0.1%
68	2	< 0.1%

num_il_tl
Numeric

Distinct count	112
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	8.520999196
Minimum	0
Maximum	159
Zeros (%)	2.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
Median	7
Q3	11
95-th percentile	23
Maximum	159
Range	159
Interquartile range	8

Descriptive statistics

Standard deviation	7.446642019
Coef of variation	0.8739165265
Kurtosis	8.241121241
Mean	8.520999196
MAD	5.367975128
Skewness	2.14446278
Sum	7481318
Variance	55.45247736
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 4.5 ... 66.5 76.5 82.5 98.5 159. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
4	76373	8.7%
3	75974	8.7%
5	72546	8.3%
2	68555	7.8%
6	66923	7.6%
7	59971	6.8%
8	52213	5.9%
1	51848	5.9%
9	44726	5.1%
10	38797	4.4%
Other values (102)	270060	30.8%

Minimum 5 values

Value	Count	Frequency (%)
0	24904	2.8%
1	51848	5.9%
2	68555	7.8%
3	75974	8.7%
4	76373	8.7%

Maximum 5 values

Value	Count	Frequency (%)
159	1	< 0.1%
140	1	< 0.1%
138	1	< 0.1%
128	1	< 0.1%
127	1	< 0.1%

num_op_rev_tl
Numeric

Distinct count	75
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	8.224300843
Minimum	0
Maximum	91
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	3
Q1	5
Median	7
Q3	10
95-th percentile	17
Maximum	91
Range	91
Interquartile range	5

Descriptive statistics

Standard deviation	4.770680929
Coef of variation	0.5800713058
Kurtosis	5.063712718
Mean	8.224300843
MAD	3.582973114
Skewness	1.575254967
Sum	7220821
Variance	22.75939653
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 43.5 49.5 56.5 63.5 91. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
6	94499	10.8%
5	92995	10.6%
7	87414	10.0%
4	82774	9.4%
8	77700	8.8%
9	66481	7.6%
3	61479	7.0%
10	55117	6.3%
11	45020	5.1%
12	36390	4.1%
Other values (65)	178117	20.3%

Minimum 5 values

Value	Count	Frequency (%)
0	468	0.1%
1	7786	0.9%
2	33332	3.8%
3	61479	7.0%
4	82774	9.4%

Maximum 5 values

Value	Count	Frequency (%)
91	2	< 0.1%
86	1	< 0.1%
79	1	< 0.1%
77	1	< 0.1%
76	1	< 0.1%

num_rev_accts
Numeric

Distinct count	104
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	13.67560417
Minimum	2
Maximum	143
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2
5-th percentile	4
Q1	8
Median	12
Q3	18
95-th percentile	29
Maximum	143
Range	141
Interquartile range	10

Descriptive statistics

Standard deviation	7.997535897
Coef of variation	0.5848031136
Kurtosis	3.863724513
Mean	13.67560417
MAD	6.089612815
Skewness	1.435779548
Sum	12006989
Variance	63.96058042
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 2. 3.5 4.5 5.5 6.5 ... 71.5 77.5 92.5 107.5 143. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
9	54275	6.2%
10	54031	6.2%
8	53939	6.1%
11	52226	5.9%
7	51351	5.8%
12	49175	5.6%
6	46661	5.3%
13	45882	5.2%
14	42423	4.8%
5	39796	4.5%
Other values (94)	388227	44.2%

Minimum 5 values

Value	Count	Frequency (%)
2	9580	1.1%
3	19643	2.2%
4	30376	3.5%
5	39796	4.5%
6	46661	5.3%

Maximum 5 values

Value	Count	Frequency (%)
143	1	< 0.1%
128	1	< 0.1%
127	1	< 0.1%
113	1	< 0.1%
112	1	< 0.1%

num_rev_tl_bal_gt_0
Highly correlated

This variable is highly correlated with num_actv_rev_tl and should be ignored for analysis

Correlation	0.9784947354

num_sats
Numeric

Distinct count	82
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	11.698092
Minimum	0
Maximum	97
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
Median	11
Q3	15
95-th percentile	23
Maximum	97
Range	97
Interquartile range	7

Descriptive statistics

Standard deviation	5.755076867
Coef of variation	0.4919671403
Kurtosis	3.525718532
Mean	11.698092
MAD	4.378381923
Skewness	1.341133268
Sum	10270761
Variance	33.12090975
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 47.5 52.5 57.5 66. 97. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
9	74825	8.5%
8	72680	8.3%
10	72582	8.3%
11	67335	7.7%
7	67182	7.7%
12	60314	6.9%
6	56758	6.5%
13	52569	6.0%
14	45423	5.2%
5	42501	4.8%
Other values (72)	265817	30.3%

Minimum 5 values

Value	Count	Frequency (%)
0	13	< 0.1%
1	572	0.1%
2	3803	0.4%
3	12742	1.5%
4	26430	3.0%

Maximum 5 values

Value	Count	Frequency (%)
97	1	< 0.1%
93	1	< 0.1%
91	1	< 0.1%
87	1	< 0.1%
85	1	< 0.1%

num_tl_30dpd
Numeric

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.003687985913
Minimum	0
Maximum	4
Zeros (%)	99.6%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	4
Range	4
Interquartile range	0

Descriptive statistics

Standard deviation	0.06353409977
Coef of variation	17.22731628
Kurtosis	411.4624593
Mean	0.003687985913
MAD	0.007349995894
Skewness	18.81592358
Sum	3238
Variance	0.004036581834
Memory size	6.7 MiB

Histogram with fixed size bins (bins=5)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 4. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	874894	99.6%
1	2958	0.3%
2	123	< 0.1%
3	10	< 0.1%
4	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	874894	99.6%
1	2958	0.3%
2	123	< 0.1%
3	10	< 0.1%
4	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
3	10	< 0.1%
2	123	< 0.1%
1	2958	0.3%
0	874894	99.6%

num_tl_90g_dpd_24m
Numeric

Distinct count	30
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.09083971726
Minimum	0
Maximum	42
Zeros (%)	94.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	42
Range	42
Interquartile range	0

Descriptive statistics

Standard deviation	0.5358187209
Coef of variation	5.89850714
Kurtosis	359.2630852
Mean	0.09083971726
MAD	0.1713638925
Skewness	14.15839184
Sum	79756
Variance	0.2871017016
Memory size	6.7 MiB

Histogram with fixed size bins (bins=30)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 10.5 12.5 15.5 20.5 42. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	828135	94.3%
1	37233	4.2%
2	7074	0.8%
3	2032	0.2%
4	1208	0.1%
5	661	0.1%
6	493	0.1%
7	308	< 0.1%
8	230	< 0.1%
9	171	< 0.1%
Other values (20)	441	0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	828135	94.3%
1	37233	4.2%
2	7074	0.8%
3	2032	0.2%
4	1208	0.1%

Maximum 5 values

Value	Count	Frequency (%)
42	1	< 0.1%
36	1	< 0.1%
30	2	< 0.1%
29	1	< 0.1%
26	1	< 0.1%

num_tl_op_past_12m
Numeric

Distinct count	33
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2.129195682
Minimum	0
Maximum	32
Zeros (%)	18.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
Median	2
Q3	3
95-th percentile	6
Maximum	32
Range	32
Interquartile range	2

Descriptive statistics

Standard deviation	1.887244228
Coef of variation	0.8863648578
Kurtosis	4.866510133
Mean	2.129195682
MAD	1.420684558
Skewness	1.534759941
Sum	1869404
Variance	3.561690775
Memory size	6.7 MiB

Histogram with fixed size bins (bins=33)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 14.5 16.5 17.5 21.5 32. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	221442	25.2%
2	191442	21.8%
0	163858	18.7%
3	133569	15.2%
4	79041	9.0%
5	41617	4.7%
6	21479	2.4%
7	11988	1.4%
8	5930	0.7%
9	3279	0.4%
Other values (23)	4341	0.5%

Minimum 5 values

Value	Count	Frequency (%)
0	163858	18.7%
1	221442	25.2%
2	191442	21.8%
3	133569	15.2%
4	79041	9.0%

Maximum 5 values

Value	Count	Frequency (%)
32	1	< 0.1%
31	1	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
28	4	< 0.1%

open_acc
Highly correlated

This variable is highly correlated with num_sats and should be ignored for analysis

Correlation	0.9988132903

out_prncp
Numeric

Distinct count	237959
Unique (%)	27.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	5457.725306
Minimum	0
Maximum	38574.22
Zeros (%)	39.3%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	2416.34
Q3	8710.76
95-th percentile	21123.9575
Maximum	38574.22
Range	38574.22
Interquartile range	8710.76

Descriptive statistics

Standard deviation	7174.495622
Coef of variation	1.314557846
Kurtosis	1.945575952
Mean	5457.725306
MAD	5622.233476
Skewness	1.545593957
Sum	4791806411
Variance	51473387.44
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-03 1.0300000e+00 8.2090000e+01 1.8433500e+02 ... 3.5829885e+04 3.5830210e+04 3.6032125e+04 3.6795180e+04 3.8574220e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	345363	39.3%
7237.84	193	< 0.1%
1779.11	185	< 0.1%
7498.9	169	< 0.1%
7526.72	167	< 0.1%
7512.78	166	< 0.1%
3558.22	162	< 0.1%
7456.78	160	< 0.1%
6742.07	154	< 0.1%
6475.96	151	< 0.1%
Other values (237949)	531116	60.5%

Minimum 5 values

Value	Count	Frequency (%)
0	345363	39.3%
0.01	1	< 0.1%
0.04	1	< 0.1%
0.05	1	< 0.1%
0.13	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
38574.22	1	< 0.1%
37600	1	< 0.1%
37540.29	1	< 0.1%
37401.02	1	< 0.1%
37340.86	1	< 0.1%

out_prncp_inv
Highly correlated

This variable is highly correlated with out_prncp and should be ignored for analysis

Correlation	0.9999980186

pct_tl_nvr_dlq
Numeric

Distinct count	649
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	93.6745726
Minimum	0
Maximum	100
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	74.1
Q1	90.7
Median	97.6
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range	9.3

Descriptive statistics

Standard deviation	9.457127757
Coef of variation	0.1009572555
Kurtosis	6.629980174
Mean	93.6745726
MAD	6.886355356
Skewness	-2.235874594
Sum	82244963.3
Variance	89.4372654
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 10.6 16.5 17.05 19.6 ... 98.75 99.05 99.25 99.7 100. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
100	425482	48.5%
90	11658	1.3%
90.9	10368	1.2%
91.7	10205	1.2%
88.9	10151	1.2%
92.3	9991	1.1%
87.5	9954	1.1%
85.7	9890	1.1%
95	9681	1.1%
92.9	9625	1.1%
Other values (639)	360981	41.1%

Minimum 5 values

Value	Count	Frequency (%)
0	6	< 0.1%
5	1	< 0.1%
5.9	1	< 0.1%
6.7	1	< 0.1%
7.1	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
100	425482	48.5%
99.4	2	< 0.1%
99.3	1	< 0.1%
99.2	4	< 0.1%
99.1	8	< 0.1%

policy_code
Constant

This variable is constant and should be ignored for analysis

Constant value	1

pub_rec
Numeric

Distinct count	35
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.2353146861
Minimum	0
Maximum	61
Zeros (%)	81.9%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	61
Range	61
Interquartile range	0

Descriptive statistics

Standard deviation	0.6390593224
Coef of variation	2.715764719
Kurtosis	403.2757727
Mean	0.2353146861
MAD	0.3853422513
Skewness	9.445952551
Sum	206603
Variance	0.4083968176
Memory size	6.7 MiB

Histogram with fixed size bins (bins=35)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 9.5 11.5 14.5 24.5 61. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	718878	81.9%
1	131388	15.0%
2	17750	2.0%
3	5669	0.6%
4	2146	0.2%
5	1019	0.1%
6	518	0.1%
7	240	< 0.1%
8	123	< 0.1%
9	87	< 0.1%
Other values (25)	168	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	718878	81.9%
1	131388	15.0%
2	17750	2.0%
3	5669	0.6%
4	2146	0.2%

Maximum 5 values

Value	Count	Frequency (%)
61	2	< 0.1%
47	1	< 0.1%
46	1	< 0.1%
45	1	< 0.1%
44	1	< 0.1%

pub_rec_bankruptcies
Numeric

Distinct count	10
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.1398530273
Minimum	0
Maximum	9
Zeros (%)	87.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	1
Maximum	9
Range	9
Interquartile range	0

Descriptive statistics

Standard deviation	0.3850018638
Coef of variation	2.752903325
Kurtosis	17.72890192
Mean	0.1398530273
MAD	0.2434774899
Skewness	3.333164487
Sum	122789
Variance	0.1482264351
Memory size	6.7 MiB

Histogram with fixed size bins (bins=10)

Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 3.5 4.5 5.5 6.5 9. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	764266	87.0%
1	106867	12.2%
2	5303	0.6%
3	1102	0.1%
4	297	< 0.1%
5	103	< 0.1%
6	35	< 0.1%
7	8	< 0.1%
8	4	< 0.1%
9	1	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	764266	87.0%
1	106867	12.2%
2	5303	0.6%
3	1102	0.1%
4	297	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
9	1	< 0.1%
8	4	< 0.1%
7	8	< 0.1%
6	35	< 0.1%
5	103	< 0.1%

purpose
Categorical

Distinct count	14
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

debt_consolidation	493982
credit_card	183075
home_improvement	65875
Other values (11)	135054

Toggle details

Common values
Composition

Value	Count	Frequency (%)
debt_consolidation	493982	56.3%
credit_card	183075	20.9%
home_improvement	65875	7.5%
other	61526	7.0%
major_purchase	21546	2.5%
medical	12325	1.4%
car	10170	1.2%
small_business	9728	1.1%
vacation	7288	0.8%
moving	6873	0.8%
Other values (4)	5598	0.6%

Max length	18
Mean length	14.75631844
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

pymnt_plan
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

n	877310
y	676

Toggle details

Value	Count	Frequency (%)
n	877310	99.9%
y	676	0.1%

recoveries
Highly correlated

This variable is highly correlated with collection_recovery_fee and should be ignored for analysis

Correlation	0.9864791705

revol_bal
Numeric

Distinct count	76815
Unique (%)	8.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	16612.13533
Minimum	0
Maximum	2559552
Zeros (%)	0.5%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1559
Q1	5810
Median	11036
Q3	19844
95-th percentile	45786
Maximum	2559552
Range	2559552
Interquartile range	14034

Descriptive statistics

Standard deviation	23524.60924
Coef of variation	1.416109896
Kurtosis	369.6307028
Mean	16612.13533
MAD	11939.00591
Skewness	10.84383952
Sum	1.458522225e+10
Variance	553407239.7
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 1.250000e+01 3.850000e+01 3.950000e+01 ... 4.337060e+05 5.741850e+05 6.700755e+05 1.065937e+06 2.559552e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	4418	0.5%
8	98	< 0.1%
10	74	< 0.1%
5262	73	< 0.1%
5453	72	< 0.1%
5125	71	< 0.1%
2	70	< 0.1%
5724	70	< 0.1%
5723	69	< 0.1%
4327	69	< 0.1%
Other values (76805)	872902	99.4%

Minimum 5 values

Value	Count	Frequency (%)
0	4418	0.5%
1	39	< 0.1%
2	70	< 0.1%
3	53	< 0.1%
4	57	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2559552	1	< 0.1%
1698749	1	< 0.1%
1696796	1	< 0.1%
1087664	1	< 0.1%
1044210	1	< 0.1%

sub_grade
Categorical

Distinct count	35
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

C1	64118
B5	62555
C4	54134
Other values (32)	697179

Toggle details

Common values
Composition

Value	Count	Frequency (%)
C1	64118	7.3%
B5	62555	7.1%
C4	54134	6.2%
C2	53682	6.1%
C3	52744	6.0%
C5	52644	6.0%
B4	52436	6.0%
B1	52329	6.0%
B3	52011	5.9%
B2	48308	5.5%
Other values (25)	333025	37.9%

Max length	2
Mean length	2
Min length	2
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

tax_liens
Numeric

Distinct count	34
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.06532792095
Minimum	0
Maximum	61
Zeros (%)	96.0%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	61
Range	61
Interquartile range	0

Descriptive statistics

Standard deviation	0.4409775114
Coef of variation	6.750214992
Kurtosis	1697.49851
Mean	0.06532792095
MAD	0.1254597339
Skewness	23.34781072
Sum	57357
Variance	0.1944611656
Memory size	6.7 MiB

Histogram with fixed size bins (bins=34)

Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 10.5 11.5 15.5 29.5 61. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	843069	96.0%
1	23465	2.7%
2	6612	0.8%
3	2455	0.3%
4	1090	0.1%
5	573	0.1%
6	289	< 0.1%
7	146	< 0.1%
8	97	< 0.1%
9	55	< 0.1%
Other values (24)	135	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
0	843069	96.0%
1	23465	2.7%
2	6612	0.8%
3	2455	0.3%
4	1090	0.1%

Maximum 5 values

Value	Count	Frequency (%)
61	2	< 0.1%
46	1	< 0.1%
45	2	< 0.1%
44	1	< 0.1%
37	1	< 0.1%

term
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

36 months	643914
60 months	234072

Toggle details

Common values
Composition

Value	Count	Frequency (%)
36 months	643914	73.3%
60 months	234072	26.7%

Max length	10
Mean length	10
Min length	10
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

tot_coll_amt
Numeric

Distinct count	11174
Unique (%)	1.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	249.6479727
Minimum	0
Maximum	932461
Zeros (%)	83.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	942
Maximum	932461
Range	932461
Interquartile range	0

Descriptive statistics

Standard deviation	2313.7487
Coef of variation	9.268045216
Kurtosis	51943.77326
Mean	249.6479727
MAD	430.3873227
Skewness	151.083683
Sum	219187425
Variance	5353433.045
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 1.000000e+00 9.500000e+00 2.450000e+01 2.550000e+01 ... 5.214000e+04 6.684800e+04 1.195805e+05 2.117700e+05 9.324610e+05], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	729825	83.1%
50	1578	0.2%
100	1326	0.2%
75	1030	0.1%
200	848	0.1%
150	833	0.1%
60	776	0.1%
70	587	0.1%
80	584	0.1%
250	537	0.1%
Other values (11164)	140062	16.0%

Minimum 5 values

Value	Count	Frequency (%)
0	729825	83.1%
2	2	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
932461	1	< 0.1%
848438	1	< 0.1%
309838	1	< 0.1%
262740	1	< 0.1%
224107	1	< 0.1%

tot_cur_bal
Numeric

Distinct count	345595
Unique (%)	39.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	144489.7479
Minimum	0
Maximum	8524709
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	8405
Q1	29598
Median	80675.5
Q3	215655
95-th percentile	447590.75
Maximum	8524709
Range	8524709
Interquartile range	186057

Descriptive statistics

Standard deviation	163040.8928
Coef of variation	1.128390734
Kurtosis	27.55432988
Mean	144489.7479
MAD	120051.5081
Skewness	2.890798826
Sum	1.268599758e+11
Variance	2.658233271e+10
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-01 6.0500000e+01 1.4725000e+03 2.6135000e+03 ... 1.6488400e+06 2.1476715e+06 2.5550790e+06 3.7710870e+06 8.5247090e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	258	< 0.1%
12794	22	< 0.1%
23520	21	< 0.1%
25344	21	< 0.1%
22373	20	< 0.1%
24830	20	< 0.1%
16053	20	< 0.1%
28171	20	< 0.1%
18837	19	< 0.1%
20084	19	< 0.1%
Other values (345585)	877546	99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	258	< 0.1%
1	7	< 0.1%
2	4	< 0.1%
3	7	< 0.1%
4	5	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
8524709	1	< 0.1%
5445012	1	< 0.1%
5172185	1	< 0.1%
4348538	1	< 0.1%
4035706	1	< 0.1%

tot_hi_cred_lim
Highly correlated

This variable is highly correlated with tot_cur_bal and should be ignored for analysis

Correlation	0.972754613

total_acc
Numeric

Distinct count	135
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	23.91298836
Minimum	2
Maximum	176
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2
5-th percentile	8
Q1	15
Median	22
Q3	30
95-th percentile	46
Maximum	176
Range	174
Interquartile range	15

Descriptive statistics

Standard deviation	11.95948862
Coef of variation	0.5001252224
Kurtosis	2.160655547
Mean	23.91298836
MAD	9.286471479
Skewness	1.071604412
Sum	20995269
Variance	143.0293681
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 2. 2.5 3.5 4.5 5.5 ... 95.5 102.5 112.5 122.5 176. ], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
20	32534	3.7%
18	32445	3.7%
19	32366	3.7%
17	32079	3.7%
21	31992	3.6%
16	31849	3.6%
22	30842	3.5%
15	30754	3.5%
23	30424	3.5%
14	29719	3.4%
Other values (125)	562982	64.1%

Minimum 5 values

Value	Count	Frequency (%)
2	508	0.1%
3	1685	0.2%
4	3882	0.4%
5	6346	0.7%
6	9505	1.1%

Maximum 5 values

Value	Count	Frequency (%)
176	1	< 0.1%
173	1	< 0.1%
165	1	< 0.1%
160	1	< 0.1%
157	1	< 0.1%

total_bal_ex_mort
Numeric

Distinct count	166421
Unique (%)	19.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	52322.54494
Minimum	0
Maximum	3408095
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	6702
Q1	21366
Median	38701
Q3	66090
95-th percentile	142814.75
Maximum	3408095
Range	3408095
Interquartile range	44724

Descriptive statistics

Standard deviation	50905.60351
Coef of variation	0.9729191033
Kurtosis	54.70301751
Mean	52322.54494
MAD	33402.83465
Skewness	3.901526222
Sum	4.593846194e+10
Variance	2591380468
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 6.250000e+01 1.472500e+03 1.951500e+03 ... 6.341540e+05 7.226855e+05 8.960355e+05 1.201214e+06 3.408095e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	485	0.1%
27673	30	< 0.1%
23915	30	< 0.1%
12794	28	< 0.1%
18720	28	< 0.1%
21641	28	< 0.1%
23366	27	< 0.1%
24830	27	< 0.1%
22702	27	< 0.1%
28739	27	< 0.1%
Other values (166411)	877249	99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	485	0.1%
1	11	< 0.1%
2	8	< 0.1%
3	11	< 0.1%
4	6	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
3408095	1	< 0.1%
2698600	1	< 0.1%
1771306	1	< 0.1%
1548128	1	< 0.1%
1501187	1	< 0.1%

total_bc_limit
Numeric

Distinct count	8349
Unique (%)	1.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	23277.08784
Minimum	0
Maximum	1105500
Zeros (%)	1.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	2300
Q1	8400
Median	16400
Q3	30400
95-th percentile	67400
Maximum	1105500
Range	1105500
Interquartile range	22000

Descriptive statistics

Standard deviation	23079.52043
Coef of variation	0.9915123654
Kurtosis	21.59122619
Mean	23277.08784
MAD	15963.72434
Skewness	2.900655075
Sum	2.043695724e+10
Variance	532664263.1
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000e+00 5.0000e+01 1.5000e+02 2.2500e+02 2.7550e+02 ... 2.4665e+05 2.7615e+05 3.3895e+05 4.2260e+05 1.1055e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	10424	1.2%
5000	6913	0.8%
6000	6163	0.7%
10000	6156	0.7%
7000	5896	0.7%
8000	5779	0.7%
4000	5624	0.6%
3000	5499	0.6%
9000	5430	0.6%
7500	5402	0.6%
Other values (8339)	814700	92.8%

Minimum 5 values

Value	Count	Frequency (%)
0	10424	1.2%
100	5	< 0.1%
200	108	< 0.1%
250	2	< 0.1%
251	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1105500	1	< 0.1%
719500	1	< 0.1%
711400	1	< 0.1%
616000	1	< 0.1%
520500	1	< 0.1%

total_il_high_credit_limit
Numeric

Distinct count	152973
Unique (%)	17.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	45490.25168
Minimum	0
Maximum	2000000
Zeros (%)	10.7%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	16122
Median	34265
Q3	60960.75
95-th percentile	128951
Maximum	2000000
Range	2000000
Interquartile range	44838.75

Descriptive statistics

Standard deviation	45931.62248
Coef of variation	1.009702536
Kurtosis	25.34514141
Mean	45490.25168
MAD	31569.8116
Skewness	3.024418596
Sum	3.993980412e+10
Variance	2109713944
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 1.800000e+01 2.830000e+02 4.995000e+02 5.005000e+02 ... 5.100310e+05 6.064700e+05 8.042645e+05 1.330168e+06 2.000000e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	94263	10.7%
10000	5578	0.6%
15000	4432	0.5%
20000	3728	0.4%
5000	3519	0.4%
12000	2868	0.3%
25000	2620	0.3%
6000	2327	0.3%
8000	2270	0.3%
7000	1496	0.2%
Other values (152963)	754885	86.0%

Minimum 5 values

Value	Count	Frequency (%)
0	94263	10.7%
36	1	< 0.1%
44	1	< 0.1%
75	1	< 0.1%
95	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2000000	1	< 0.1%
1736064	1	< 0.1%
1349413	1	< 0.1%
1310923	1	< 0.1%
1285625	1	< 0.1%

total_pymnt
Numeric

Distinct count	606059
Unique (%)	69.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	10444.12374
Minimum	0
Maximum	59808.26209
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1722.64
Q1	4416.04
Median	7955.52
Q3	13866.1625
95-th percentile	28047.28842
Maximum	59808.26209
Range	59808.26209
Interquartile range	9450.1225

Descriptive statistics

Standard deviation	8409.701654
Coef of variation	0.8052089255
Kurtosis	2.404868468
Mean	10444.12374
MAD	6363.453108
Skewness	1.532553823
Sum	9169794425
Variance	70723081.91
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 8.29000000e+00 9.92150000e+01 2.48445000e+02 2.99060000e+02 ... 4.89998743e+04 5.04308900e+04 5.22586704e+04 5.51628641e+04 5.98082621e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	392	< 0.1%
9031.54	110	< 0.1%
3515.31	108	< 0.1%
4642.74	96	< 0.1%
3127.87	94	< 0.1%
3590.61	94	< 0.1%
18063.09	92	< 0.1%
3646.44	92	< 0.1%
3441.1	89	< 0.1%
9028.59	88	< 0.1%
Other values (606049)	876731	99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	392	< 0.1%
16.58	1	< 0.1%
17.58	1	< 0.1%
30.7	1	< 0.1%
33.63	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
59808.26209	1	< 0.1%
58559.128	1	< 0.1%
57459.75603	1	< 0.1%
56642.01229	1	< 0.1%
56109.34	1	< 0.1%

total_pymnt_inv
Highly correlated

This variable is highly correlated with total_pymnt and should be ignored for analysis

Correlation	0.9999946425

total_rec_int
Numeric

Distinct count	373667
Unique (%)	42.6%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	2168.23948
Minimum	0
Maximum	22644.05
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	202.66
Q1	715.9225
Median	1470.505
Q3	2887.845
95-th percentile	6455.6475
Maximum	22644.05
Range	22644.05
Interquartile range	2171.9225

Descriptive statistics

Standard deviation	2157.487331
Coef of variation	0.9950410697
Kurtosis	7.160820834
Mean	2168.23948
MAD	1548.358239
Skewness	2.222608116
Sum	1903683908
Variance	4654751.585
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.0000000e+00 5.0000000e-03 4.0000000e-02 3.8500000e-01 1.1950000e+00 ... 1.6771795e+04 1.8346100e+04 1.9041215e+04 2.0831800e+04 2.2644050e+04], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	1236	0.1%
960.93	123	< 0.1%
753.15	107	< 0.1%
810.65	102	< 0.1%
872.71	98	< 0.1%
972.78	94	< 0.1%
634.17	92	< 0.1%
584.65	92	< 0.1%
1621.31	90	< 0.1%
1104.51	82	< 0.1%
Other values (373657)	875870	99.8%

Minimum 5 values

Value	Count	Frequency (%)
0	1236	0.1%
0.01	16	< 0.1%
0.07	2	< 0.1%
0.12	1	< 0.1%
0.19	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
22644.05	1	< 0.1%
22559.92	1	< 0.1%
22117.12	1	< 0.1%
22088.55	1	< 0.1%
21997.72	1	< 0.1%

total_rec_late_fee
Numeric

Distinct count	7058
Unique (%)	0.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.536038639
Minimum	-3.9e-09
Maximum	1198.89
Zeros (%)	96.2%

Toggle details

Quantile statistics

Minimum	-3.9e-09
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	1198.89
Range	1198.89
Interquartile range	0

Descriptive statistics

Standard deviation	11.85547305
Coef of variation	7.718212781
Kurtosis	815.3171504
Mean	1.536038639
MAD	2.954951753
Skewness	20.29350981
Sum	1348620.42
Variance	140.5522413
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[-3.90000e-09 -2.00000e-10 1.50000e-10 1.18500e-08 9.57000e+00 ... 2.58480e+02 3.53290e+02 4.82090e+02 7.53495e+02 1.19889e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	844499	96.2%
15	8178	0.9%
30	1677	0.2%
45	548	0.1%
60	249	< 0.1%
75	124	< 0.1%
16.49	72	< 0.1%
15.00000001	66	< 0.1%
16.61	63	< 0.1%
19.78	58	< 0.1%
Other values (7048)	22452	2.6%

Minimum 5 values

Value	Count	Frequency (%)
-3.9e-09	1	< 0.1%
-2e-09	1	< 0.1%
-4e-10	1	< 0.1%
0	844499	96.2%
3e-10	2	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1198.89	1	< 0.1%
1188.83	1	< 0.1%
883.31	1	< 0.1%
801.6	1	< 0.1%
765	1	< 0.1%

total_rec_prncp
Highly correlated

This variable is highly correlated with total_pymnt_inv and should be ignored for analysis

Correlation	0.9665829516

total_rev_hi_lim
Numeric

Distinct count	17911
Unique (%)	2.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	34778.91482
Minimum	0
Maximum	2175000
Zeros (%)	0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	5900
Q1	14600
Median	25500
Q3	43300
95-th percentile	92000
Maximum	2175000
Range	2175000
Interquartile range	28700

Descriptive statistics

Standard deviation	35445.19158
Coef of variation	1.019157492
Kurtosis	99.81228952
Mean	34778.91482
MAD	21788.39337
Skewness	5.771171984
Sum	3.05354003e+10
Variance	1256361606
Memory size	6.7 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 5.000000e+01 2.500000e+02 3.500000e+02 4.500000e+02 ... 5.736385e+05 6.854500e+05 7.780000e+05 1.165400e+06 2.175000e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
10000	2959	0.3%
11000	2734	0.3%
14000	2731	0.3%
15000	2718	0.3%
13000	2711	0.3%
11500	2701	0.3%
16000	2682	0.3%
12000	2681	0.3%
12500	2627	0.3%
14500	2612	0.3%
Other values (17901)	850830	96.9%

Minimum 5 values

Value	Count	Frequency (%)
0	584	0.1%
100	12	< 0.1%
200	25	< 0.1%
300	140	< 0.1%
400	48	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2175000	1	< 0.1%
1827401	1	< 0.1%
1652700	1	< 0.1%
1649101	1	< 0.1%
1629000	1	< 0.1%

verification_status
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

Source Verified	352959
Not Verified	285462
Verified	239565

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Source Verified	352959	40.2%
Not Verified	285462	32.5%
Verified	239565	27.3%

Max length	15
Mean length	12.11459978
Min length	8
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

Count
Matrix

First rows

	acc_open_past_24mths	addr_state	annual_inc	application_type	collection_recovery_fee	debt_settlement_flag	delinq_2yrs	df_index	disbursement_method	earliest_cr_line	fico_range_high	fico_range_low	funded_amnt	funded_amnt_inv	grade	hardship_flag	home_ownership	initial_list_status	installment	int_rate	issue_d	last_fico_range_high	last_fico_range_low	last_pymnt_amnt	loan_amnt	loan_status	mo_sin_old_rev_tl_op	mo_sin_rcnt_rev_tl_op	mo_sin_rcnt_tl	mort_acc	num_accts_ever_120_pd	num_actv_bc_tl	num_actv_rev_tl	num_bc_sats	num_bc_tl	num_il_tl	num_op_rev_tl	num_rev_accts	num_rev_tl_bal_gt_0	num_sats	num_tl_90g_dpd_24m	num_tl_op_past_12m	open_acc	out_prncp	out_prncp_inv	pct_tl_nvr_dlq	policy_code	pub_rec	pub_rec_bankruptcies	purpose	pymnt_plan	recoveries	revol_bal	sub_grade	term	tot_coll_amt	tot_cur_bal	tot_hi_cred_lim	total_acc	total_bal_ex_mort	total_bc_limit	total_il_high_credit_limit	total_pymnt	total_pymnt_inv	total_rec_int	total_rec_late_fee	total_rec_prncp	total_rev_hi_lim	verification_status
0	6	IN	108329.0	Individual	0.0000	N	1	0	Cash	Mar-96	699	695	26000	26000.0	C	N	RENT	w	894.82	14.49	Sep-16	669	665	894.82	26000	Current	246	6	6	0	0	4	8	5	6	11	14	19	8	21	0	4	21	9968.30	9968.30	89.7	1	0	0	car	n	0.00	12300	C4	36 months	0	56283	126593	30	56283	18200	93993	21523.300000	21523.30	5402.12	89.48	16031.70	32600	Not Verified
1	4	FL	75000.0	Individual	0.0000	N	0	1	Cash	Apr-86	799	795	12000	12000.0	A	N	MORTGAGE	f	361.38	5.32	Sep-16	809	805	10533.60	12000	Fully Paid	365	13	13	7	0	7	7	12	15	5	15	21	7	20	0	0	20	0.00	0.00	100.0	1	0	0	home_improvement	n	0.00	19897	A1	36 months	0	242695	486000	33	37584	153700	39000	12333.411430	12333.41	333.41	0.00	12000.00	167000	Not Verified
2	8	TX	56000.0	Individual	228.7458	Y	0	2	Cash	Sep-03	674	670	3000	3000.0	C	N	MORTGAGE	w	102.52	13.99	Sep-16	629	625	102.52	3000	Charged Off	133	3	3	2	0	2	4	2	2	5	5	6	4	9	0	3	9	0.00	0.00	100.0	1	1	1	debt_consolidation	n	1270.81	5466	C3	36 months	0	99733	112925	13	22032	2700	27025	1778.750000	1778.75	162.25	0.00	345.69	5900	Source Verified
3	3	NC	110000.0	Individual	0.0000	N	0	3	Cash	Oct-77	704	700	8000	8000.0	A	N	MORTGAGE	f	249.19	7.59	Sep-16	744	740	284.19	8000	Current	467	9	9	1	3	10	13	11	19	7	19	40	13	22	0	3	22	2206.31	2206.31	89.6	1	0	0	debt_consolidation	n	0.00	46404	A3	36 months	0	257939	365263	48	55664	56300	19763	6594.620000	6594.62	800.93	0.00	5793.69	75500	Source Verified
4	4	IL	75000.0	Individual	0.0000	N	0	4	Cash	Apr-08	664	660	18000	18000.0	C	N	RENT	w	423.42	14.49	Sep-16	509	505	423.42	18000	Charged Off	32	5	5	0	0	3	4	3	3	3	4	4	4	5	0	1	5	0.00	0.00	85.7	1	0	0	debt_consolidation	n	0.00	6469	C4	60 months	0	15803	26627	7	15803	12700	12827	5475.480000	5475.48	2593.62	0.00	2881.86	13800	Not Verified
5	5	CA	65000.0	Individual	0.0000	N	0	5	Cash	Nov-92	704	700	32200	32200.0	D	N	MORTGAGE	w	880.02	21.49	Sep-16	734	730	31447.60	32200	Fully Paid	286	3	3	3	0	3	5	5	10	7	14	24	5	17	0	2	17	0.00	0.00	100.0	1	1	1	credit_card	n	0.00	11987	D5	60 months	0	173513	199969	34	24934	13900	15886	35770.812750	35770.81	3570.81	0.00	32200.00	24900	Not Verified
6	3	OR	35000.0	Individual	0.0000	N	0	6	Cash	Sep-09	774	770	2600	2600.0	B	N	RENT	w	82.67	8.99	Sep-16	764	760	2492.06	2600	Fully Paid	61	13	13	0	0	4	5	6	8	14	7	10	5	14	0	0	14	0.00	0.00	100.0	1	0	0	moving	n	0.00	720	B1	36 months	0	19497	73227	24	19497	50200	20527	2662.590238	2662.59	62.59	0.00	2600.00	52700	Source Verified
7	7	OK	65000.0	Individual	0.0000	N	0	7	Cash	Jul-04	709	705	1000	1000.0	C	N	OWN	w	33.94	13.49	Sep-16	699	695	820.22	1000	Fully Paid	146	4	4	2	0	3	3	5	6	8	6	11	3	9	0	4	9	0.00	0.00	100.0	1	0	0	other	n	0.00	12501	C2	36 months	78	109761	131469	21	23568	29100	13000	1090.243921	1090.24	90.24	0.00	1000.00	30100	Verified
8	11	OR	60000.0	Individual	0.0000	N	2	8	Cash	Sep-98	699	695	12000	12000.0	D	N	MORTGAGE	w	311.23	18.99	Sep-16	714	710	12107.09	12000	Fully Paid	216	4	1	8	1	2	8	5	9	6	17	23	8	19	2	9	19	0.00	0.00	78.4	1	0	0	major_purchase	n	0.00	7935	D3	60 months	0	272439	290671	37	43438	11000	35386	12704.232870	12704.23	704.23	0.00	12000.00	21600	Not Verified
9	8	IL	95000.0	Individual	0.0000	N	0	9	Cash	May-93	674	670	8000	8000.0	C	N	MORTGAGE	w	268.75	12.79	Sep-16	644	640	268.75	8000	Current	280	6	2	3	0	3	8	4	6	8	10	19	8	12	0	7	12	3023.53	3023.53	96.4	1	1	1	debt_consolidation	n	0.00	11343	C1	36 months	0	30705	44176	30	30705	15000	20476	6446.680000	6446.68	1470.21	0.00	4976.47	23700	Verified

Last rows

	acc_open_past_24mths	addr_state	annual_inc	application_type	collection_recovery_fee	debt_settlement_flag	delinq_2yrs	df_index	disbursement_method	earliest_cr_line	fico_range_high	fico_range_low	funded_amnt	funded_amnt_inv	grade	hardship_flag	home_ownership	initial_list_status	installment	int_rate	issue_d	last_fico_range_high	last_fico_range_low	last_pymnt_amnt	loan_amnt	loan_status	mo_sin_old_rev_tl_op	mo_sin_rcnt_rev_tl_op	mo_sin_rcnt_tl	mort_acc	num_accts_ever_120_pd	num_actv_bc_tl	num_actv_rev_tl	num_bc_sats	num_bc_tl	num_il_tl	num_op_rev_tl	num_rev_accts	num_rev_tl_bal_gt_0	num_sats	num_tl_op_past_12m	open_acc	out_prncp	out_prncp_inv	pct_tl_nvr_dlq	policy_code	pub_rec	pub_rec_bankruptcies	purpose	pymnt_plan	recoveries	revol_bal	sub_grade	term	tot_coll_amt	tot_cur_bal	tot_hi_cred_lim	total_acc	total_bal_ex_mort	total_bc_limit	total_il_high_credit_limit	total_pymnt	total_pymnt_inv	total_rec_int	total_rec_prncp	total_rev_hi_lim	verification_status
877976	4	OR	60000.0	Individual	0.0000	N	1	97844	Cash	Jun-97	684	680	19600	19600.0	B	N	MORTGAGE	w	430.76	11.47	Apr-16	689	685	430.76	19600	Current	225	24	23	5	0	6	7	7	10	24	10	20	7	14	0	14	11188.99	11188.99	98.0	1	0	0	debt_consolidation	n	0.00	22358	B5	60 months	0	228358	280001	49	76160	17500	72841	12979.000000	12979.00	4567.99	8411.01	29700	Not Verified
877977	5	CA	139000.0	Individual	511.0074	N	0	97845	Cash	Oct-03	664	660	28000	28000.0	G	N	MORTGAGE	w	883.16	28.67	Apr-16	674	670	883.16	28000	Charged Off	86	9	5	1	3	2	3	2	5	5	5	9	3	8	3	8	0.00	0.00	78.6	1	0	0	credit_card	n	2838.93	3777	G4	60 months	1345	315577	359339	15	128115	5000	130782	10742.770000	10742.77	5781.23	2122.61	21700	Not Verified
877978	9	VA	59000.0	Individual	0.0000	N	0	97846	Cash	Aug-93	709	705	22400	22400.0	G	N	RENT	w	702.05	28.34	Apr-16	694	690	702.05	22400	Current	271	4	4	0	0	2	11	2	9	11	14	29	11	16	7	16	15308.97	15308.97	100.0	1	0	0	debt_consolidation	n	0.00	93022	G3	60 months	0	121963	147496	40	121963	10100	42996	20324.180000	20324.18	13233.15	7091.03	104500	Source Verified
877979	8	NY	57900.0	Individual	0.0000	N	0	97847	Cash	Nov-05	674	670	13350	13350.0	G	N	RENT	w	418.41	28.34	Apr-16	559	555	418.41	13350	Current	91	8	8	0	0	5	9	7	10	16	13	17	9	24	3	24	9142.76	9142.76	71.0	1	0	0	debt_consolidation	n	0.00	9762	G3	60 months	0	93545	88750	33	93545	11300	67950	12222.020000	12222.02	8014.78	4207.24	20800	Not Verified
877980	4	PA	67000.0	Individual	0.0000	N	6	97848	Cash	Apr-91	669	665	5000	5000.0	B	N	OWN	w	157.59	8.39	Apr-16	654	650	157.59	5000	Current	299	2	2	1	0	6	7	8	11	12	14	23	7	16	1	16	922.55	922.55	68.6	1	0	0	debt_consolidation	n	0.00	10524	B1	36 months	170	27029	63658	36	27029	29800	27458	4725.370000	4725.37	647.92	4077.45	36200	Not Verified
877981	6	IN	45000.0	Individual	0.0000	N	0	97849	Cash	Apr-84	689	685	7000	7000.0	A	N	MORTGAGE	w	210.81	5.32	Apr-16	709	705	210.81	7000	Current	383	16	6	3	2	3	5	3	12	5	8	26	5	9	2	9	1449.88	1449.88	68.6	1	0	0	debt_consolidation	n	0.00	5307	A1	36 months	0	72196	80800	35	5307	9700	0	6122.790000	6122.79	572.67	5550.12	13600	Source Verified
877982	8	IN	48000.0	Individual	0.0000	N	0	97850	Cash	Jul-04	699	695	21475	21475.0	D	N	MORTGAGE	w	536.84	17.27	Apr-16	544	540	536.84	21475	Charged Off	140	3	3	1	0	5	5	8	9	8	15	18	5	17	3	17	0.00	0.00	100.0	1	1	1	debt_consolidation	n	0.00	17496	D2	60 months	0	135850	180325	27	46645	27800	45025	8548.230000	8548.23	4482.69	4065.54	37100	Source Verified
877983	1	OH	50000.0	Individual	0.0000	N	1	97851	Cash	Sep-00	684	680	6050	6050.0	D	N	MORTGAGE	w	154.46	18.25	Apr-16	709	705	4878.63	6050	Fully Paid	186	8	8	2	0	12	20	20	20	1	20	31	21	21	1	22	0.00	0.00	97.0	1	0	0	credit_card	n	0.00	34947	D3	60 months	0	154480	171397	34	37619	22250	0	7646.641827	7646.64	1596.64	6050.00	38950	Source Verified
877984	7	LA	591000.0	Individual	0.0000	N	0	97852	Cash	Sep-95	754	750	30000	30000.0	D	N	MORTGAGE	w	778.06	18.99	Apr-16	539	535	778.06	30000	Charged Off	246	1	1	3	1	1	1	4	6	22	9	15	2	15	5	15	0.00	0.00	97.3	1	0	0	debt_consolidation	n	0.00	55154	D4	60 months	0	109139	168698	40	109139	54100	61098	15650.900000	15650.90	8580.01	7070.89	107600	Not Verified
877985	2	IN	52000.0	Individual	0.0000	N	0	97853	Cash	Aug-02	669	665	5000	5000.0	B	N	MORTGAGE	w	163.11	10.75	Apr-16	764	760	163.11	5000	Current	163	3	3	1	0	3	4	3	4	0	5	7	4	6	1	6	948.38	948.38	100.0	1	2	1	credit_card	n	0.00	3979	B4	36 months	1445	142211	161200	8	3979	5200	0	4890.310000	4890.31	838.69	4051.62	6200	Not Verified

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows